<?php

namespace App\Jobs\Publish;

use Illuminate\Bus\Queueable;
use Illuminate\Queue\SerializesModels;
use Illuminate\Queue\InteractsWithQueue;
use Illuminate\Contracts\Queue\ShouldQueue;
use Illuminate\Foundation\Bus\Dispatchable;
use Illuminate\Support\Facades\DB;
use App\Models\Task\Task;
use App\Models\Entity\Column\Album;
use App\Models\Entity\Column\AlbumVasseti;
use Encore\Admin\Facades\Admin;
use App\Classes\Publish\Publication;

class AlbumJob implements ShouldQueue
{
    use Dispatchable, InteractsWithQueue, Queueable, SerializesModels;
    protected $ids;
    protected $option;
    public $tries = 1;
    public $timeout = 30;
    public $taskid;
    // 上线,下线,发布的where条件
    protected $upWhere          = ['online_status' => 0, 'publish_down_status' => 1];
    protected $publishWhere     = ['online_status' => 1, 'publish_status'      => 0];
    protected $downWhere        = ['online_status' => 1];
    protected $publishDownWhere = ['online_status' => 0, 'publish_down_status' => 0];
    
    /**
     * Create a new job instance.
     *
     * @return void
     */
    public function __construct($option, $ids='', $taskid='')
    {
        $this->option = $option;
        $this->ids    = $ids;
        $this->taskid = $taskid;
    }

    /**
     * Execute the job.
     *
     * @return void
     */
    public function handle()
    {
        switch ($this->option[0]) {
            // 分发任务,将一个大任务划分为多个小任务
            case 'dispatch':
                $this->mydispatch($this->option[1]);
                break;
            // 上线小任务
            case 'up':
                $user_id = Publication::getField(new Task(), $this->taskid, 'user_id');
                // 查询出有多少专题有媒资
                $hasVassetiIds = AlbumVasseti::whereIn('album_id', $this->ids)->pluck('album_id')->unique();
                Publication::updateMany(new Album(), $hasVassetiIds, [
                    'online_status'       => 1, 
                    'publish_down_status' => 0, 
                    'user_id'             => $user_id, 
                    'online_at'           => date('Y-m-d H:i:s')
                ]);
                Publication::updateOne(new Task(), $this->taskid, [
                    // 已完成的数量是有专题的栏目总数
                    'done_num' => DB::raw('done_num +'.count($hasVassetiIds)),
                ]);
                break;
            // 发布小任务
            case 'publish':
                $publish_small_chunk_num = config('custom.base.job.album.publish_small_chunk_num');
                foreach ($this->ids->chunk($publish_small_chunk_num) as $chunk_ids) {
                    try {
                        $albums = Album::with(['cols', 'vassetis'])->whereIn('id',$chunk_ids)->get();
                    } catch(\Exception $e) {
                        dd($e->getMessage());
                    }
                    // 拼装产品包数据, 产品包-媒资中间表数据
                    $album_datas = self::makeAlbums($albums);
                    DB::connection('interface')->beginTransaction();
                    try {
                        DB::connection('interface')->table('albums')->insert($album_datas);
                        DB::connection('interface')->commit();
                        Publication::updateMany(new Album(), $chunk_ids, ['publish_status' => 1]);
                        Publication::updateOne(new Task(), $this->taskid, [
                            'done_num' => DB::raw('done_num + '.count($chunk_ids))
                        ]);
                    } catch (\Exception $e) {
                        DB::connection('interface')->rollback(); //事务回滚
                        dd($e->getMessage());
                    }
                }
                break;
            // 下线小任务
            case 'down':
                $user_id = Publication::getField(new Task(), $this->taskid, 'user_id');
                Publication::updateMany(new Album(), $this->ids, [
                    'online_status'  => 0, 
                    'publish_status' => 0, 
                    'user_id'        => $user_id, 
                    'offline_at'     => date('Y-m-d H:i:s')
                ]);
                Publication::updateOne(new Task(), $this->taskid, ['done_num' => DB::raw('done_num +' . count($this->ids))]);
                break;
            // 下线发布小任务
            case 'publishDown':
                $user_id = Publication::getField(new Task(), $this->taskid, 'user_id');
                Publication::deleteApi('albums', 'album_id', $this->ids);
                Publication::updateMany(new Album(), $this->ids, [
                    'publish_down_status' => 1, 
                    'user_id'             => $user_id, 
                ]);
                Publication::updateOne(new Task(), $this->taskid, ['done_num' => DB::raw('done_num +' . count($this->ids))]);
                break;
        }
    }
    
    /**
    * 分发任务具体执行代码
    */
    public function mydispatch($option)
    {
        switch ($option) {
            case 'up':
                $chunk_num = config('custom.base.job.album.online_chunk_num');
                $where = $this->upWhere;
                break;
            case 'publish':
                $chunk_num = config('custom.base.job.album.publish_chunk_num');
                $where = $this->publishWhere;
                break;
            case 'down':
                $chunk_num = config('custom.base.job.album.offline_chunk_num');
                $where = $this->downWhere;
                break;
            case 'publishDown':
                $chunk_num = config('custom.base.job.album.publish_chunk_num');
                $where = $this->publishDownWhere;
                break;
        }
        Publication::chunk(new Album(), $this, $where, $chunk_num, [$option]);
    }
      
    /**
    * 拼装专题数据
    */
    public static function makeAlbums($albums)
    {
        $datas = [];
        $data  = [];
        foreach ($albums as $album) {
            $data['album_id']    = $album->id;
            $data['name']        = $album->name;
            $data['title']       = $album->title;
            $data['subtitle']    = $album->subtitle;
            $data['long_desc']   = $album->long_desc;
            $data['short_desc']  = $album->short_desc;
            $data['backimg']     = $album->backimg;
            if ($album->cols->first()) {
                $data['columns'] = $album->cols->toJson();
            } else {
                $data['columns'] = '';
            }
            $data['vassetis']    = $album->vassetis->toJson();
            $datas[]             = $data;
        }
        return $datas;
    }
}
